Oracle DB データ移行

Oracle DB データ移行(Oracle DB data migration)

エクスポート

code:sql

SQL> CREATE OR REPLACE DIRECTORY DATA_DIR AS '/home/user/dump';

code:shell

expdp system/**** FULL=Y CONTENT=METADATA_ONLY \

INCLUDE=USER,ROLE,GRANT \

DIRECTORY=dpdir DUMPFILE=security_meta.dmp LOGFILE=security_meta.log

# 有効な object_type は実DBで:

# SELECT object_path FROM DATABASE_EXPORT_OBJECTS WHERE object_path LIKE '%GRANT' OR object_path IN ('USER','ROLE');

FULL=Y: 全体エクスポート・モード

code:sh

expdp system/**** FULL=Y CONTENT=METADATA_ONLY \

INCLUDE=USER,ROLE,GRANT \

DIRECTORY=dpdir DUMPFILE=security_meta.dmp LOGFILE=security_meta.log

code:sh

expdp system/**** SCHEMAS=SCOTT \

DIRECTORY=dpdir DUMPFILE=scott_%U.dmp LOGFILE=scott.log PARALLEL=4

確認用

Q. Oracle DB データ移行